Staircase Join: Teach a Relational DBMS to Watch its (Axis) Steps

Relational query processors derive much of their effectiveness from the awareness of specific table properties like sort order, size, or absence of duplicate tuples. This text applies (and adapts) this successful principle to database-supported XML and XPath processing: the relational system is made tree aware, i.e., tree properties like subtree size, intersection of paths, inclusion or disjointness of subtrees are made explicit. We propose a local change to the database kernel, the staircase join, which encapsulates the necessary tree knowledge needed to improve XPath performance. Staircase join operates on an XML encoding which makes this knowledge available at the cost of simple integer operations (e.g., +, <=). We finally report on quite promising experiments with a staircase join enhanced main-memory database kernel

P-equilibrium fertilization in an intensive dairy farming system: effects on soil-P status, crop yield and P leaching

In the coming decade, European dairy farms are obliged to realize a balance between phosphor (P) inputs to their farmland (in inorganic fertilizers and manure) and outputs (in crop products), the so-called P-equilibrium fertilization. The objective of the present study is to analyze the long-term effects of P-equilibrium fertilization on soil-P status (total soil-P and available soil-P), crop yield and P leaching on dry sandy soil, using data from experimental dairy farm ‘De Marke’, where P-equilibrium fertilization has been applied since 1989. For grassland, P availability is expressed in P-Al and for arable land in Pw. Total and available P status were monitored in the upper topsoil (layer 0–0.2 m). Total soil-P was also monitored in the lower topsoil (layer 0.2–0.4 m) and in the subsoil (0.4–0.6 m). From 1989 to 2006, Pw and P-Al (means of all farmland) decreased by 26 and 25%, respectively. In the same period, mean total-P content of the farmland decreased by 16%. There was a large variation in initial P status (1989) of the various plots. The rate of decline in all soil-P indicators was positively correlated to their initial values. In plots with the lowest initial values, P status did not change, while in plots with high initial values it tended to stabilize at lower levels. At equilibrium-P fertilization, Pw is estimated to stabilize at 20. This is lower than the recommended P status of Dutch soils used for maize cropping. P-Al is estimated to stabilize at 30–40, which corresponds to the current recommendations for grassland. The data show that at P-equilibrium fertilization, soil available-P status is higher in a maize-ley rotation than in permanent grassland. The decline in total P and available P did not affect crop yield, nor did it affect the P concentration in groundwater, but at ‘De Marke’, P emission to groundwater is generally low. The results obtained suggest that P-equilibrium fertilization can be compatible with efficient crop productio

Moa and the multi-model architecture: a new perspective on XNF2

Advanced non-traditional application domains such as geographic information systems and digital library systems demand advanced data management support. In an effort to cope with this demand, we present the concept of a novel multi-model DBMS architecture which provides evaluation of queries on complexly structured data without sacrificing efficiency. A vital role in this architecture is played by the Moa language featuring a nested relational data model based on XNF2, in which we placed renewed interest. Furthermore, extensibility in Moa avoids optimization obstacles due to black-box treatment of ADTs. The combination of a mapping of queries on complexly structured data to an efficient physical algebra expression via a nested relational algebra, extensibility open to optimization, and the consequently better integration of domain-specific algorithms, makes that the Moa system can efficiently and effectively handle complex queries from non-traditional application domains

MonetDB/XQuery: a fast XQuery processor powered by a relational engine

Relational XQuery systems try to re-use mature relational data management infrastructures to create fast and scalable XML database technology. This paper describes the main features, key contributions, and lessons learned while implementing such a system. Its architecture consists of (i) a range-based encoding of XML documents into relational tables, (ii) a compilation technique that translates XQuery into a basic relational algebra, (iii) a restricted (order) property-aware peephole relational query optimization strategy, and (iv) a mapping from XML update statements into relational updates. Thus, this system implements all essential XML database functionalities (rather than a single feature) such that we can learn from the full consequences of our architectural decisions. While implementing this system, we had to extend the state-of-the-art with a number of new technical contributions, such as loop-lifted staircase join and efficient relational query evaluation strategies for XQuery theta-joins with existential semantics. These contributions as well as the architectural lessons learned are also deemed valuable for other relational back-end engines. The performance and scalability of the resulting system is evaluated on the XMark benchmark up to data sizes of 11GB. The performance section also provides an extensive benchmark comparison of all major XMark results published previously, which confirm that the goal of purely relational XQuery processing, namely speed and scalability, was met

The direct and indirect effects of nitrogen shortage on photosynthesis and transpiration in maize and sunflower.

Experiments with maize and sunflower in sol. culture were carried out to investigate the effect of N shortage in the leaf tissue on stomatal behaviour. In maize a linear relation existed between the rate of net CO2 assimilation and the conductance of water vapour, independently of the N status of the tissue. In sunflower a similar relation existed although the evidence was less conclusive. It was concluded that stomatal behaviour cannot explain differences in water-use efficiency between plants growing at different levels of N. (Abstract retrieved from CAB Abstracts by CABI’s permission